Logical Provenance in Data-Oriented Workflows∗ (Long Version)

We consider the problem of defining, generating, and tracing provenance in dataoriented workflows, in which input data sets are processed by a graph of transformations to produce output results. We first give a new general definition of provenance for general transformations, introducing the notions of correctness, precision, and minimality. We then determine when properties such as correctness and minimality carry over from the individual transformations’ provenance to the workflow provenance. We describe a simple logical-provenance specification language consisting of attribute mappings and filters. We provide algorithms for provenance tracing in workflows where logical provenance for each transformation is specified using our language. We consider logical provenance in the relational setting, showing that for a class of Select-Project-Join (SPJ) transformations, logical provenance specifications encode minimal provenance. We have built a prototype system supporting the features and algorithms presented in the paper, and we report a few preliminary experimental results.